-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE UpdateControl 
	-- Add the parameters for the stored procedure here.
	@id int,
	@formId int,
	@name varchar,
	@width int,
	@height int,
	@top int,
	@left int,
	@font varchar,
	@defaultValue varchar,
	@tooltipText varchar,
	@summaryField int,
	@status int,
	@listTextId int
AS
BEGIN

	UPDATE    FormsControls
SET              FormID = @formId, Name = @name, Width = @width, Height = @height, LocationTop = @top, LocationLeft = @left, Font = @font, DefaultValue = @defaultValue, 
                      ToolTipText = @toolTipText, SummaryField = @summaryField, Status = @status, ListTextID = @listTextId
WHERE     (ID = @id)
	
END
GO
